| saBillingMethod |
| Logical Entity Name | saBillingMethod |
| Default Table Name | saBillingMethod |
| Physical Only | NO |
| Definition | |
| Note |
| saBillingMethod Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
saBillingMethodID |
int | NO | ||
| Code | char(8) | NO | ||
| Descrip | varchar(50) | NO | ||
| Frequency | char(1) | NO | ||
| RateBasis | char(1) | NO | ||
| UseRateSchedule | bit | NO | ||
| AutoBill | bit | NO | ||
| Active | bit | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| UserID | int | NO | ||
| ts | timestamp | NO | ||
| EffectiveDateFlag | char(1) | NO | ||
| ByCampus | bit | NO | ||
| AlwaysBillRegFee | bit | NO | ||
| CheckSchedule | bit | NO | ||
AdCourseLevelID |
int | NO | ||
| PostBillingDetails | bit | NO | ||
| ImmediatePosting | bit | NO | ||
| InitChargesOffSetDays | int | YES | ||
| TransDate | char(1) | YES | ||
| RequireReview | bit | NO | ||
| ChargeOn | char(1) | NO | ||
| AllowCourseFeeSchedule | bit | NO | ||
| AutoPostDropAdjust | bit | YES | ||
| TermGroupBilling | bit | YES | ||
| AutoCorrectDetails | bit | YES |
| saBillingMethod Primary and Unique Keys |
| Key Name | Key Type | Keys |
| saBillingMethod_saBillingMethodID_U_C_IDX | PrimaryKey | saBillingMethodID |
| saBillingMethod Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdCourseLevel | Non-Identifying | One To Zero or More | FK_saBillingMethod_AdCourseLevelID_AdCourseLevel_AdCourseLevelID | AdCourseLevelID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| amAgencyBranch | Non-Identifying | One To Zero or More | FK_AmAgencyBranch.SaBillingMethodID_SaBillingMethod.SaBillingMethodID | NO | YES | |||
| SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetail_SaBillingMethodID_saBillingMethod_saBillingMethodID | NO | YES | |||
| SaBillingMethodExternalMap | Non-Identifying | One To Zero or More | FK_SaBillingMethodExternalMapSaBillingMethodId_SaBillingMethodSaBillingMethodId | NO | YES |
| saBillingMethod Check Constraints |
| Check Constraint Name | CheckConstraint |